What is your AutoComplete in Excel issue?

Responses:

AutoComplete does not work for data in another range
AutoComplete does not work with extended character
Computer appears to hang using Pick from list
Pick from List not using all data from different blocks
Typing is ignored when a pick list is being displayed
Error: Some list items ignored when creating custom lists
How to: Turn AutoComplete off
How to: Turn AutoComplete on
How to: Use Pick from list